<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<%@ include file="../master/head.jsp"%>
<%@ include file="IsStudent.jsp"%>
</head>
<body>
<div id="container">
<div id="wrapper">
<div id="sidebar">
<div id="sb_top"><%@ include file="../master/sbTop.jsp"%>
</div>

<div class="sb_content"><!--##########--> <!-- Start Menu --> <%@ include
	file="../master/studentMenu.jsp"%> <!-- Profile -->
<%@ include file="../master/profile.jsp"%> <!-- links -->
<%@ include file="../master/links.jsp"%>
<div class="copyright"><%@ include file="../master/copyright.jsp"%>
</div>

</div>
<!-- /sb_content --></div>
<!-- /sidebar --> <!-- Top -->
<div id="header"><%@ include file="../master/header.jsp"%>
</div>


<!-- Start main content -->
<div id="content">
<div id="intro">
<div class="intro_t">
<h1><span>..</span>Welcome to<span>..</span></h1>
<h2>student project managment system</h2>

</div>
</div>
<!-- /intro --> <%@ page import="java.util.*,java.sql.*"%>
<%
                    String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
                    
                    try {
                    int id=(Integer) session.getAttribute("id");
                    
                    String projectPro = request.getParameter("setProj");
                    String projId = request.getParameter("projId");
                    
                    if (Integer.parseInt(projectPro) == -1)
						response.sendRedirect("index.jsp");

                    Class.forName(driver);
                    
                    Connection connection = DriverManager.getConnection("jdbc:odbc:SPMS","","");
                    
                    Statement statement = connection.createStatement();
                    
                    out.println("<h1>Hi "+session.getAttribute("un")+" <a href='logout.jsp' >LOGOUT</a></h1>");
                    
                    String query = "SELECT * FROM StudentProject WHERE StudentId="+ id + "AND ProjectId ="+projId+" and pro = " +projectPro;
                    ResultSet res = statement.executeQuery(query);
                    if (!res.next())
                    {
                    	query = "delete from StudentProject WHERE StudentId="+ id + "and pro = " +projectPro;
                        statement.executeUpdate(query);
                    	query = "delete from StudentProject WHERE StudentId="+ id + "AND ProjectId ="+projId;
                    	statement.executeUpdate(query);
                    	query = "INSERT INTO StudentProject(StudentId,ProjectId,pro) values ( "+ id +","+ projId +","+projectPro+")";
                    	statement.executeUpdate(query);
                    }
                    }catch(ClassNotFoundException cnfe) {
                    out.println("No such class: " + driver);
                    } catch(SQLException se) {
                    out.println("SQLException: " + se);
                    }
                    
                    %>
</div>
<!-- /content --></div>
<!-- /wrapper -->
<div class="clear">&nbsp;</div>
<!-- Important! Fix the problem of height in Firefox --></div>
<!-- /Container -->


</body>
</html>